﻿CREATE PROCEDURE [dbo].[usp_getentityidfromname]
	@categoryid bigint,
	@entityname nvarchar(50)
AS
	SELECT ID
	FROM Entities
	WHERE Entities.Name = @entityname and Entities.Category = @categoryid
RETURN 0